2015-07-16 - 20736 - Spec - Vendor capacity report #vendormaster #PurchaseOrders #CrystalReportDevelopment
SPECIFICATIONS 20736.100 - Spec - Vendor Capacity Report
Purpose
Report to analyze the Vendor Capacity.
Admin Info
| Purpose |
Vendor Capacity report |
| Requested By |
Jeffrey Mau |
| Spec Created By |
Laxman |
| Spec Created Date |
07/16/2015 |
| Spec QA by |
Laxman |
| Objects |
Tables:J_3ASUCAH J_3APOCAP EKKO EKPO |
| Document Status |
Complete |
Estimates
Phase 1:
| Sl.No |
Activity |
Estimation in Hours |
| 1 |
Research |
08 |
| 2 |
Documentation |
08 |
| 3 |
Development/ Config |
40 |
| 4 |
Unit test in DEV |
10 |
| 5 |
Unit test in QUA |
|
| 6 |
Other activity |
|
| TOTAL |
66 |
Phase 2:
| Sl.No |
Activity |
Estimation in Hours |
| 1 |
Research |
|
| 2 |
Documentation |
|
| 3 |
Development/ Config |
120 |
| 4 |
Unit test in DEV |
20 |
| 5 |
Unit test in QUA |
|
| 6 |
Other activity |
|
| TOTAL |
140 |
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]Documents
[Attach any document(s) received for the requirement(s)]
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
| Sl. |
Change Details |
Requested By |
Requested On |
Notes if any |
| 01 |
New Report with different format |
Jeff Mau |
08/07/2015 |
|
| 02 |
Actual values by plant |
Jeff Mau |
08/14/2015 |
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]Create Vendor capacity crystal report as shown below. By using this report vendor capacity will be analyzed and can react to market changes without having to buildup high warehouse stocks.
In Scope:
[List the activities to be included in scope]Out of Scope:
[Out of scope activities]Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
By using the standard vendor capacity report will get only vendor capacity and consumed capacity. But as per the business we also need order quantity by ICD (actual). So to full fill the requirement as shown below (in Phase 2) need to create a crystal report to analyze the vendor capacity. This report will contain vendor capacity, Consumed capacity and order quantity by ICD date to do the planning at vendor. But to get the quicker benefits better implement this requirement in two phases.
Phase 01: Report with Projected (Vendor capacity) and Actual (Order quantity by ICD) values as shown below. Estimate for phase 01 is 60 - 70 Hrs.
Vendor Capacity: Maximum capacity that vendor can manufacture in that period.
- For this we need to activate the vendor capacity.
- Assign maximum capacity for each vendor.
- Tentative estimate for this: 8 Hrs.
Actual (Order qty by ICD): Sum of purchase order quantity from that vendor in that period (ICD date should be in this period).
Finally by joining the J_3ASUCAH, EKKO and EKPO tables as shown above need to create the crystal report.
- Tentative estimate for this: 32 Hrs.
Phase 02: Report with standard vendor capacity. This report will contain vendor capacity, consumed capacity and order qty by ICD (Actual) as shown below. For this we need implement the vendor capacity including assignment of materials to vendor. Estimate for phase 02 is 140 - 160 Hrs.
Consumed capacity: Sum of order quantity given to that vendor in that period.
- For this we need to activate the vendor capacity and implement OSS note to get the correct values.
- Maintain the capacity for each vendor.
- Assign materials to the vendor and specify the manufacturing time.
- Tentative estimate for this: 80 - 100 Hrs
Create LSMW to assign the materials to vendor and modify the existing material creation programs.
- Tentative estimate for this: 32 - 40 Hrs.
Finally we need to modify the crystal report created in phase 01 to add the Consumed capacity as shown above.
- Tentative estimate for this: 16 Hrs.
Jeff advised to create a new report in the below given format on 08/07/2015.
Asian Sourcing JAN FEB MAR APR
Planned
Actual
Variance
Percent
Mainland JAN FEB MAR APR
Planned
Actual
Variance
Percent
Jeff advised to modify the report to show actuals by plant on 08/14/2015.
Test Plan
[List test scenarios/cases to be executed here]
| Test ID |
Test Scenario |
Expected Results |
| MM001 |
Create different types of purchase orders like NB, PTO, TPO and Subcontracting and validate the consumed capacity using standard vednor capacity report |
Consumed capacity should match with POs created |
| MM002 |
Execute the crystal report and validate the values |
Values should be correct |
[Provide complete technical details for configuration or programming here]
- Activate the vendor capacity business function.
- Implement the OSS notes to get the correct values in the standard vendor capacity report
- Create the LSMW to assign the materials to vendor
- Modify the material creation program to assign materials to vendor.
- Finally by using below given tables and fields create the crystal report as shown above.
- Since data is more need to execute this report daily as a batch Job.
J_3ASUCAH - J_3ATOTCAP
J_3ASUCAH - J_3ACONCAP
EKKO-LIFNR
EKKO-EBELN
EKPO-EBELN
EKPO-J_3AEXFCP
Issues
[List Issues / Bugs identified in configuration or development]